package com.pantuo.sys.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.pantuo.sys.pojo.StatisticsThree;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.Collection;

@Mapper
public interface StatisticsThreeDao extends BaseMapper<StatisticsThree> {

    public void insertAndUpdate(@Param("statisticsThrees") Collection<StatisticsThree> statisticsThrees);

    @Select("select all_i from tn_statisticsthree where date_s = #{date_s} and vehicleNum1_s = #{vehicleNum1_s}")
    public int selectCountByDateAndVehicleNum1(String date_s, String vehicleNum1_s);


    @Delete("delete from tn_statisticsthree where date_s = #{date_s} and vehicleNum1_s = #{vehicleNum1_s}")
    public void deleteByDateAndVehicleNum1(String date_s, String vehicleNum1_s);
}
